Editing XML Index Advanced

Allow row locks
Row locks are allowed when accessing the index. The Database Engine determines when row locks are used.

Allow page locks
Page locks are allowed when accessing the index. The Database Engine determines when page locks are used.

Create/Rebuild Option

Fill Factor (%)
Specify a percentage that indicates how full the Database Engine should make the leaf level of each index page during index creation or rebuild. Fill Factor must be an integer value from 1 to 100.

Pad index
The percentage of free space that is specified by fillfactor is applied to the intermediate-level pages of the index.

Sort in tempdb
Specify to store temporary sort results in tempdb.

Max. degree of parallelism
Override the max degree of parallelism configuration option for the duration of the index operation.